numbers type turns to different format, etc.

  • Thread starter Thread starter aboiy
  • Start date Start date
A

aboiy

Hi again,

Whenever i type a number and hit enter, there is a time it
translate the value to different format.

A - when i type:
1 - 21/05 it will appear as "21-May-2003"
2 - 71590351 it will appear as "7E+07"

B - Also the string =today() is useful for our day to day
transaction but whenever i open the previous transaction
its still giving me the present date.

C - I have a hidden column but whenever i copy a set
columns wherein this hidden column is situated in between
them, it also been copied as well.

Is there a way to overcome these problems?

aboiy
 
aboiy said:
Hi again,

Whenever i type a number and hit enter, there is a time it
translate the value to different format.

A - when i type:
1 - 21/05 it will appear as "21-May-2003"
2 - 71590351 it will appear as "7E+07"

B - Also the string =today() is useful for our day to day
transaction but whenever i open the previous transaction
its still giving me the present date.

C - I have a hidden column but whenever i copy a set
columns wherein this hidden column is situated in between
them, it also been copied as well.

Is there a way to overcome these problems?
Click to expand...

A1. What do you want to appear when you type 21/05? If you want the five
characters you type just as a text string, format the cell as text before
typing in the data.

A2. How is your cell formatted? The appearance of the number 71590351
doesn't change for me when entered in a cell formatted as General. However,
this will happen if it's formatted as Scientific.

B. Use CTRL+; (hold down CTRL whilst pressing semicolon) to enter the
current date in a form that will not change tomorrow.

C. You just have to copy the columns to the left and to the right of your
hidden column separately, or delete the unwanted column after pasting.
 
Paul,

a. im trying to type the 5 characters '21/05' as it is.
c. i can't delete the hidden column, it contains the
manhour calculation.

Everything is ok now. Following your advised and
explanation, everything becomes clear. Im sure i know now
what to do the next time it occurs again.

Thank and regards.

aboiy
 
aboiy

C. Drag/select the columns including the hidden one. Hit F5>Special>Visible
cells only>OK. Now do your copy and the hidden one won't be copied.

Gord Dibben XL2002
 
Back
Top