Cell formats keep changing

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

Is there a way that I can prevent cells from changing
format when I enter information? On my spreadsheet I am
pulling information from different worksheets but when the
data populates, the format changes. If I am pulling a
general number, it changes to 00:00:00 format, and when I
am pulling time format, it switches from the two different
00:00:00 formats. I don't know what the difference is in
the two of these formats listed, but I know that I need
the second one. Hope this makes sense. tia
 
00:00:00 format
00:00:00 formats

so far it would be hard to tell the difference. hh:mm:ss AM/PM shows 12
hour time, hh:mm:ss shows "military" time (0 to 24 hrs), [hh]:mm:ss shows
"military" style time but is designed for time greater than 24 hours -
possibly total or elapsed time

Pulling information and populating - vague terminology that doesn't provide
much insight into what you are doing or how you are doing it.

regards,
Tom Ogilvy
 
Tom,

I'm pulling information from other worksheets with index
and match. I guess it's more like a template that takes
raw data from four different worksheets to create a report
with just the data that I need. The problem is that when
the information comes into my report, the formatting is
different. I then format the whole column to what I need
but when I add the next days information, it comes over
different again and I have to go back and format again.
Is there possibly a macro that I can use that will change
to the format I need when I enter the data?


-----Original Message-----
00:00:00 format
00:00:00 formats

so far it would be hard to tell the difference. hh:mm:ss AM/PM shows 12
hour time, hh:mm:ss shows "military" time (0 to 24 hrs), [hh]:mm:ss shows
"military" style time but is designed for time greater than 24 hours -
possibly total or elapsed time

Pulling information and populating - vague terminology that doesn't provide
much insight into what you are doing or how you are doing it.

regards,
Tom Ogilvy


Is there a way that I can prevent cells from changing
format when I enter information? On my spreadsheet I am
pulling information from different worksheets but when the
data populates, the format changes. If I am pulling a
general number, it changes to 00:00:00 format, and when I
am pulling time format, it switches from the two different
00:00:00 formats. I don't know what the difference is in
the two of these formats listed, but I know that I need
the second one. Hope this makes sense. tia
Click to expand...


.
Click to expand...
 
Sub SetFormat()
Selection.NumberFormat = "hh:mm:ss AM/PM"
End Sub

as an example.

--
Regards,
Tom Ogilvy

Brian said:
Tom,

I'm pulling information from other worksheets with index
and match. I guess it's more like a template that takes
raw data from four different worksheets to create a report
with just the data that I need. The problem is that when
the information comes into my report, the formatting is
different. I then format the whole column to what I need
but when I add the next days information, it comes over
different again and I have to go back and format again.
Is there possibly a macro that I can use that will change
to the format I need when I enter the data?


-----Original Message-----
00:00:00 format
00:00:00 formats

so far it would be hard to tell the difference. hh:mm:ss AM/PM shows 12
hour time, hh:mm:ss shows "military" time (0 to 24 hrs), [hh]:mm:ss shows
"military" style time but is designed for time greater than 24 hours -
possibly total or elapsed time

Pulling information and populating - vague terminology that doesn't provide
much insight into what you are doing or how you are doing it.

regards,
Tom Ogilvy


Is there a way that I can prevent cells from changing
format when I enter information? On my spreadsheet I am
pulling information from different worksheets but when the
data populates, the format changes. If I am pulling a
general number, it changes to 00:00:00 format, and when I
am pulling time format, it switches from the two different
00:00:00 formats. I don't know what the difference is in
the two of these formats listed, but I know that I need
the second one. Hope this makes sense. tia
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top