| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
format numbers as text - not working
I have a pre-populated date field, and have attempted to reformat it to text,
and when I do I get a random number instead of my date. My date field starts as: 21-Dec-1999 and when I change the FORMAT to TEXT, the content now appears as follows: 36515 (on the left side of the cell) clearly this field is not staying "exactly as you typed it" Why is this happening and what can I do? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format text to numbers | Excel Discussion (Misc queries) | |||
| Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
| Text to Numbers NOT working | Excel Discussion (Misc queries) | |||
| My filter is not working for numbers & text | New Users to Excel | |||
| How do i change numbers in text format to number format? | New Users to Excel | |||
Threaded Mode
