Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Format
When I key numbers into a cell, the format returned is not what is keyed
in....and no matter what format I change it too, it stays the same. HELP!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Format
In what way do they vary? Give a few examples. Do you have a decimal
point inserted? Does the number become a date? Are the numbers changed completely? Pete On Oct 1, 4:53 pm, pm hudson <pm wrote: When I key numbers into a cell, the format returned is not what is keyed in....and no matter what format I change it too, it stays the same. HELP!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Format
What do you mean - When I key numbers... and no matter what format I change
it too, it stays the same. I do not understand the problem!? "pm hudson" <pm wrote in message ... When I key numbers into a cell, the format returned is not what is keyed in....and no matter what format I change it too, it stays the same. HELP!! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Format
When I key numbers into a cell, the format returned is not
what is keyed in....and no matter what format I change it too, it stays the same. HELP!! It would really help if you told us what numbers you were keying in, what "format" you were seeing for it and what "format" you were expecting to see. Otherwise, we cannot know what your problem is. Rick |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Format
For example: If I key 109 into a cell, it returns 0.00109.
"Pete_UK" wrote: In what way do they vary? Give a few examples. Do you have a decimal point inserted? Does the number become a date? Are the numbers changed completely? Pete On Oct 1, 4:53 pm, pm hudson <pm wrote: When I key numbers into a cell, the format returned is not what is keyed in....and no matter what format I change it too, it stays the same. HELP!! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Format
For example....when I key 109 into a cell, it returns 0.00109. All numbers
are converted in this way. It adds 0.00 to each number entered. Even when changing the formatting, it still returns the same number. "Rick Rothstein (MVP - VB)" wrote: When I key numbers into a cell, the format returned is not what is keyed in....and no matter what format I change it too, it stays the same. HELP!! It would really help if you told us what numbers you were keying in, what "format" you were seeing for it and what "format" you were expecting to see. Otherwise, we cannot know what your problem is. Rick |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Format
Tools/Options/Edit uncheck the Fixed Decimal Places checkbox...
In article , pm hudson wrote: For example....when I key 109 into a cell, it returns 0.00109. All numbers are converted in this way. It adds 0.00 to each number entered. Even when changing the formatting, it still returns the same number. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Format
Tools/ Options/ Edit/ Unset Fixed decimal places
-- David Biddulph "pm hudson" wrote in message ... For example....when I key 109 into a cell, it returns 0.00109. All numbers are converted in this way. It adds 0.00 to each number entered. Even when changing the formatting, it still returns the same number. "Rick Rothstein (MVP - VB)" wrote: When I key numbers into a cell, the format returned is not what is keyed in....and no matter what format I change it too, it stays the same. HELP!! It would really help if you told us what numbers you were keying in, what "format" you were seeing for it and what "format" you were expecting to see. Otherwise, we cannot know what your problem is. Rick |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Format
THANKS SOOOO MUCH!!!
"JE McGimpsey" wrote: Tools/Options/Edit uncheck the Fixed Decimal Places checkbox... In article , pm hudson wrote: For example....when I key 109 into a cell, it returns 0.00109. All numbers are converted in this way. It adds 0.00 to each number entered. Even when changing the formatting, it still returns the same number. |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell Format
THANK YOU SOOOOO MUCH!
"David Biddulph" wrote: Tools/ Options/ Edit/ Unset Fixed decimal places -- David Biddulph "pm hudson" wrote in message ... For example....when I key 109 into a cell, it returns 0.00109. All numbers are converted in this way. It adds 0.00 to each number entered. Even when changing the formatting, it still returns the same number. "Rick Rothstein (MVP - VB)" wrote: When I key numbers into a cell, the format returned is not what is keyed in....and no matter what format I change it too, it stays the same. HELP!! It would really help if you told us what numbers you were keying in, what "format" you were seeing for it and what "format" you were expecting to see. Otherwise, we cannot know what your problem is. Rick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
Can cell format come from and change with reference cell format | Excel Discussion (Misc queries) | |||
Custom Cell format to mimic time format | Excel Discussion (Misc queries) | |||
How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) |