Copied number (format as text) increases

  • Thread starter Thread starter James Wagner
  • Start date Start date
J

James Wagner

Hi all.
I have a funny thing.

Formatted a column as text.
Put a number in row 1 - e.g. 50.00
Drag the number to row 2 -> the new cell value is 50.01.
Delete the number and try dragging to 10 cells - the new cells value
increases from 50.01 to 50.10...


Going to write the value - manually ....LOL

Please advise.
TIA
Guy
 
please pressing "Ctrl" to drawing!!

I am chinese, i can't say more that in english!
so, i can't help you more!!!
 
Worked fine
Thank you sire!!!
Guy

?... said:
please pressing "Ctrl" to drawing!!

I am chinese, i can't say more that in english!
so, i can't help you more!!!
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

if value is between two numbers 6
A way to increase a number in a cell by using the + key 2
Excel lookup across entire workbook 1
Cut and paste from web pages, emails, is breaking up text into multipleExcel cells 3
Incrementing, Even Though Formatted As Text: Why ? 6
Need Adaptable Macro 9
MACRO RUN random percentage and copy of column values 1
Excel VBA 1

Back
Top